FO_Client_Provs

This table is used to cross reference clients to providers. It allows you to map one or more clients to a provider code. The system will execute this rule at the time the User picks an ordering physician in the order screen.

Each record in this table represents a single Provider code Client Code pair.

 

Field Type Notes

ClientCode

varchar(50)

Enter a unique client code.

ProviderCode

varchar(50)

Provider code for this client.

Enter a valid provider code.

ClientProviders_ID

int

ID field, a counter. Unique

EditDate

datetime

Date record was last edited.

Informational

CreateDate

datetime

Date record was created.

Informational